Read the Student-Support Problem

Scenario

The UniLearn support team has student-progress records but can contact only five students first. The query must combine eligibility, academic risk, the requested output columns, and a precise priority order.

The Practical Question

Which five eligible, at-risk students should the team contact first?

Separate who is eligible, who is at risk, and how priority is decided before thinking about SQL. Use student_progress as the source table.

QUERY REQUIREMENTSUp to 5 rows

Use this checklist to complete the query diagram and later verify the SQL.

ELIGIBLE

student_status = 'active'ANDsupport_status = 'not_contacted'

AT RISK

attendance_percent < 75ORaverage_mark < 50ORmissed_assignments >= 2

SHOW

student_idstudent_nameprogrammeattendance_percentaverage_markmissed_assignments

PRIORITY

More missed assignments first
Then lower average marks
Then lower student IDs

Student Progress Evidence

The chart shows all 12 practice records using attendance, average mark, missed assignments, and eligibility status.

Student progress evidence

Each point is one record in student_progress. Position shows attendance and mark; point size shows missed assignments.

Student-progress scatter plot with attendance and average-mark thresholds